import openpyxl
myBook=openpyxl.load_workbook('城市排名表.xlsx')
mySheet=myBook.active
myRows=list(mySheet.rows)[1:]
for myRow in myRows:
	myList=myRow[1].value.split('、')
	mySet=set(myList)
	myRow[1].value='、'.join(mySet)
myBook.save('结果表-城市排名表.xlsx')
